﻿IF EXISTS (SELECT * from sys.procedures p left join sys.schemas s on p.schema_id = s.schema_id where p.name='account_update' and s.name='Budget')
DROP PROCEDURE [Budget].account_update
GO
CREATE PROCEDURE [Budget].account_update 
@PK uniqueidentifier, 
@Name nvarchar(100)
AS
BEGIN
UPDATE [Budget].[Accounts] 
SET	[name] = @Name 
WHERE
	[id_account] = @PK 
END